The following document provides an initial descriptive analysis and data coverage overview of the [Annual Survey of State and Local Government Finances. The data is provided in a standardised format from Willamette University. The data is available at a county level between 1967 - 2020 with improved coverage in more recent years. The below data overview incorporates only data from 2001-2020 (can be expanded easily). The data has been cleaned and grouped into 17 expenditure categories (listed in data tree below), 4 higher-level categories (comprised of the 17 lower-level categories), and as a county-level total expenditure. All plots are presented using the raw data, whereas the tables presenting the linear time trend results include results for both the raw data and linearly interpolated data.
The data is currently structured in county-year pairs with observations for 17 public expenditure categories. I have manually grouped these 17 categories into 4 higher categories (that can be changed/redefined easily!). The tree structure below displays all categories and groupings. As currently thought out, any or a combination of these categories will serve as outcome/dependent variables.
## levelName
## 1 Total Public Expenditure
## 2 ¦--Commercial
## 3 ¦ ¦--Air Transportation
## 4 ¦ ¦--Liquor Stores
## 5 ¦ °--Port Facilities
## 6 ¦--Public Welfare, Services & Facilities
## 7 ¦ ¦--Education
## 8 ¦ ¦--Fire Protection
## 9 ¦ ¦--Health & Hospitals
## 10 ¦ ¦--Housing & Community Development
## 11 ¦ ¦--Public Services & Facilities
## 12 ¦ ¦--Public Transit
## 13 ¦ ¦--Public Welfare
## 14 ¦ °--Retirement
## 15 ¦--Administration & Misc.
## 16 ¦ ¦--General Administration
## 17 ¦ ¦--Interest on Debt
## 18 ¦ °--NEC
## 19 °--Infrastructure, Utilities & Regulation
## 20 ¦--Highways
## 21 ¦--Police, Corrections & Judicial
## 22 ¦--Protective Inspection & Regulation
## 23 ¦--Utilities
## 24 °--Waste Management & Sewerage
The below plots provide aggregated geographical (national, state, regional) summaries of expenditure categories and shares to demonstrate the composition of national expenditure across the categories. The final two plots demonstrate the composition of expenditure within the Public Welfare, Services & Facilities category.
The animations below show the data coverage at a county level of the 4 broad categories (purple) and total expenditure values (green). Coverage is strong at this level. (Apologies for the poor arrangement!)
## [1] 58102
The following tables provide standard linear time trends evaluated in
a county-fixed effects panel linear regression model for a panel of
3,037 counties and for a time period of 2001-2020.
Dependent variables: Expenditure by category in levels and per
capita values.
Data: Raw data and linearly interpolated data.
Result: Expenditure levels increase (as seen in overview graphs) but per capita expenditure remains stationary.
| Outcome Variable |
|
|
|
|
|---|---|---|---|---|
| Commercial | 33.61*** | 37.65*** | 0*** | 0*** |
| 1.63 | 1.63 | 0 | 0 | |
| Administration Misc | 461.43*** | 501.24*** | 0*** | 0*** |
| 4.9 | 4.88 | 0 | 0 | |
| Infrastructure Utilities Regulation | 885.02*** | 957.29*** | 0*** | 0*** |
| 10.53 | 10.49 | 0 | 0 | |
| Public Welfare Services Facilities | 1566.59*** | 1659.56*** | 0*** | 0*** |
| 24.49 | 24.44 | 0 | 0 |
| Outcome Variable |
|
|
|
|
|---|---|---|---|---|
| Public Transit | -0.81. | 7.16*** | 0 | 0*** |
| 0.46 | 0.38 | 0 | 0 | |
| Port Facilities | 4.73*** | 2.73*** | 0*** | 0*** |
| 0.37 | 0.22 | 0 | 0 | |
| Liquor Stores | 6.56*** | 4.16*** | 0*** | 0*** |
| 0.4 | 0.27 | 0 | 0 | |
| Protective Inspection Regulation | 12.29*** | 9.62*** | 0*** | 0*** |
| 0.21 | 0.15 | 0 | 0 | |
| Air Transportation | 39.35*** | 35.07*** | 0*** | 0*** |
| 2.11 | 1.54 | 0 | 0 | |
| Housing Community Development | 50.21*** | 35.64*** | 0*** | 0*** |
| 1.33 | 0.91 | 0 | 0 | |
| Retirement | 78.28*** | 88.2*** | 0*** | 0*** |
| 4.6 | 3.63 | 0 | 0 | |
| Fire Protection | 89.41*** | 63.67*** | 0*** | 0*** |
| 2.34 | 1.61 | 0 | 0 | |
| Utilities | 122.05*** | 81.12*** | 0*** | 0*** |
| 3.21 | 2.05 | 0 | 0 | |
| Interest On Debt | 141.53*** | 99.57*** | 0*** | 0*** |
| 2.62 | 1.82 | 0 | 0 | |
| Waste Management Sewerage | 154.54*** | 109.59*** | 0*** | 0*** |
| 2.6 | 1.8 | 0 | 0 | |
| General Administration | 175.9*** | 131.49*** | 0*** | 0*** |
| 1.58 | 1.1 | 0 | 0 | |
| Public Services Facilities | 218.09*** | 155.71*** | 0*** | 0*** |
| 3.13 | 2.17 | 0 | 0 | |
| Highways | 230.94*** | 177.21*** | 0*** | 0*** |
| 2.33 | 1.62 | 0 | 0 | |
| Nec | 374.44*** | 273.48*** | 0*** | 0*** |
| 4.37 | 3.04 | 0 | 0 | |
| Public Welfare | 434.72*** | 307.85*** | 0*** | 0*** |
| 9.61 | 6.64 | 0 | 0 | |
| Education | 654.92*** | 467.84*** | 0*** | 0*** |
| 11.05 | 7.65 | 0 | 0 | |
| Police Corrections Judicial | 806.11*** | 578.78*** | 0.01*** | 0.01*** |
| 10.36 | 7.18 | 0 | 0 | |
| Health Hospitals | 838.21*** | 587.63*** | 0.01*** | 0.01*** |
| 16.54 | 11.44 | 0 | 0 |